create or replace view vac_app_page_ir_col_4_1 as
with ir_col as (
select
  workspace,
  application_id,
  application_name,
  page_id,
  interactive_report_id,
  region_id,
  column_id,
  column_alias,
  to_char(display_order) display_order,
  column_group,
  column_group_id,
  report_label,
  form_label,
  column_link,
  column_linktext,
  column_link_attr,
  column_link_checksum_type,
  allow_sorting,
  allow_filtering,
  allow_highlighting,
  allow_ctrl_breaks,
  allow_aggregations,
  allow_computations,
  allow_charting,
  allow_group_by,
  allow_hide,
  column_type,
  display_text_as,
  heading_alignment,
  column_alignment,
  format_mask,
  tz_dependent,
  filter_lov_source,
  named_lov,
  rpt_lov,
  filter_date_ranges,
  display_condition_type,
  display_condition,
  display_condition2,
  help_text,
  authorization_scheme,
  authorization_scheme_id,
  column_expr,
  component_comment,
  created_on,
  created_by,
  updated_on,
  updated_by,
  component_signature
from APEX_APPLICATION_PAGE_IR_COL
)
select
  workspace,
  application_id,
  application_name,
  page_id,
  interactive_report_id,
  column_group_id,
  column_alias,
  region_id,
  u_name,
  u_value,
  'APEX_APPLICATION_PAGE_IR_COL' src_view_name
from ir_col
UNPIVOT INCLUDE NULLS(u_value FOR u_name IN
 (
  display_order,
  column_group,
  report_label,
  form_label,
  column_link,
  column_linktext,
  column_link_attr,
  column_link_checksum_type,
  allow_sorting,
  allow_filtering,
  allow_highlighting,
  allow_ctrl_breaks,
  allow_aggregations,
  allow_computations,
  allow_charting,
  allow_group_by,
  allow_hide,
  column_type,
  display_text_as,
  heading_alignment,
  column_alignment,
  format_mask,
  tz_dependent,
  filter_lov_source,
  named_lov,
  rpt_lov,
  filter_date_ranges,
  display_condition_type,
  display_condition,
  display_condition2,
  help_text,
  authorization_scheme,
  column_expr,
  component_comment
 )
);

